﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DSFatura" targetNamespace="http://tempuri.org/DSFatura.xsd" xmlns:mstns="http://tempuri.org/DSFatura.xsd" xmlns="http://tempuri.org/DSFatura.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Karbel4ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Karbel4ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TX.Properties.Settings.GlobalReference.Default.Karbel4ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FaturaTableAdapter" GeneratorDataComponentClassName="FaturaTableAdapter" Name="Fatura" UserDataComponentName="FaturaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.Fatura" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Fatura] WHERE (([FaturaId] = @Original_FaturaId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FaturaId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Fatura] ([PurchaseOrderId], [Tarih], [BelgeTipiId], [FaturaTarihi], [FaturaNo], [IrsaliyeTarihi], [IrsaliyeNo], [VendorId], [isClosed], [OwnerId], [CurrencyCode], [Freight], [GrandTotal], [AlisSekliId], [PaymentTermId], [DeliveryTermId], [ExpensePercentageId], [CarrierId], [ReferansNo], [ModifiedDate], [ModifiedBy]) VALUES (@PurchaseOrderId, @Tarih, @BelgeTipiId, @FaturaTarihi, @FaturaNo, @IrsaliyeTarihi, @IrsaliyeNo, @VendorId, @isClosed, @OwnerId, @CurrencyCode, @Freight, @GrandTotal, @AlisSekliId, @PaymentTermId, @DeliveryTermId, @ExpensePercentageId, @CarrierId, @ReferansNo, @ModifiedDate, @ModifiedBy);
SELECT FaturaId, PurchaseOrderId, Tarih, BelgeTipiId, FaturaTarihi, FaturaNo, IrsaliyeTarihi, IrsaliyeNo, VendorId, isClosed, OwnerId, CurrencyCode, Freight, GrandTotal, AlisSekliId, PaymentTermId, DeliveryTermId, ExpensePercentageId, CarrierId, ReferansNo, ModifiedDate, ModifiedBy, TS FROM Fatura WHERE (FaturaId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PurchaseOrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PurchaseOrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Tarih" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Tarih" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@BelgeTipiId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="BelgeTipiId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FaturaTarihi" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="FaturaTarihi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FaturaNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FaturaNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@IrsaliyeTarihi" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="IrsaliyeTarihi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IrsaliyeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IrsaliyeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isClosed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isClosed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OwnerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Freight" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GrandTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@AlisSekliId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="AlisSekliId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PaymentTermId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PaymentTermId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@DeliveryTermId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="DeliveryTermId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@ExpensePercentageId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="ExpensePercentageId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CarrierId" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CarrierId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ReferansNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ReferansNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT FaturaId, PurchaseOrderId, Tarih, BelgeTipiId, FaturaTarihi, FaturaNo, IrsaliyeTarihi, IrsaliyeNo, VendorId, isClosed, OwnerId, CurrencyCode, Freight, GrandTotal, AlisSekliId, PaymentTermId, DeliveryTermId, ExpensePercentageId, CarrierId, ReferansNo, ModifiedDate, ModifiedBy, TS FROM dbo.Fatura</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Fatura] SET [PurchaseOrderId] = @PurchaseOrderId, [Tarih] = @Tarih, [BelgeTipiId] = @BelgeTipiId, [FaturaTarihi] = @FaturaTarihi, [FaturaNo] = @FaturaNo, [IrsaliyeTarihi] = @IrsaliyeTarihi, [IrsaliyeNo] = @IrsaliyeNo, [VendorId] = @VendorId, [isClosed] = @isClosed, [OwnerId] = @OwnerId, [CurrencyCode] = @CurrencyCode, [Freight] = @Freight, [GrandTotal] = @GrandTotal, [AlisSekliId] = @AlisSekliId, [PaymentTermId] = @PaymentTermId, [DeliveryTermId] = @DeliveryTermId, [ExpensePercentageId] = @ExpensePercentageId, [CarrierId] = @CarrierId, [ReferansNo] = @ReferansNo, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([FaturaId] = @Original_FaturaId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT FaturaId, PurchaseOrderId, Tarih, BelgeTipiId, FaturaTarihi, FaturaNo, IrsaliyeTarihi, IrsaliyeNo, VendorId, isClosed, OwnerId, CurrencyCode, Freight, GrandTotal, AlisSekliId, PaymentTermId, DeliveryTermId, ExpensePercentageId, CarrierId, ReferansNo, ModifiedDate, ModifiedBy, TS FROM Fatura WHERE (FaturaId = @FaturaId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PurchaseOrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PurchaseOrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Tarih" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Tarih" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@BelgeTipiId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="BelgeTipiId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FaturaTarihi" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="FaturaTarihi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FaturaNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FaturaNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@IrsaliyeTarihi" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="IrsaliyeTarihi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IrsaliyeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IrsaliyeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isClosed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isClosed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OwnerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OwnerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@CurrencyCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="CurrencyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Freight" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GrandTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@AlisSekliId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="AlisSekliId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PaymentTermId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PaymentTermId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@DeliveryTermId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="DeliveryTermId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@ExpensePercentageId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="ExpensePercentageId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CarrierId" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CarrierId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ReferansNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ReferansNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FaturaId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="FaturaId" ColumnName="FaturaId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@FaturaId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FaturaId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FaturaId" DataSetColumn="FaturaId" />
              <Mapping SourceColumn="PurchaseOrderId" DataSetColumn="PurchaseOrderId" />
              <Mapping SourceColumn="Tarih" DataSetColumn="Tarih" />
              <Mapping SourceColumn="BelgeTipiId" DataSetColumn="BelgeTipiId" />
              <Mapping SourceColumn="FaturaTarihi" DataSetColumn="FaturaTarihi" />
              <Mapping SourceColumn="FaturaNo" DataSetColumn="FaturaNo" />
              <Mapping SourceColumn="IrsaliyeTarihi" DataSetColumn="IrsaliyeTarihi" />
              <Mapping SourceColumn="IrsaliyeNo" DataSetColumn="IrsaliyeNo" />
              <Mapping SourceColumn="VendorId" DataSetColumn="VendorId" />
              <Mapping SourceColumn="isClosed" DataSetColumn="isClosed" />
              <Mapping SourceColumn="OwnerId" DataSetColumn="OwnerId" />
              <Mapping SourceColumn="CurrencyCode" DataSetColumn="CurrencyCode" />
              <Mapping SourceColumn="Freight" DataSetColumn="Freight" />
              <Mapping SourceColumn="GrandTotal" DataSetColumn="GrandTotal" />
              <Mapping SourceColumn="AlisSekliId" DataSetColumn="AlisSekliId" />
              <Mapping SourceColumn="PaymentTermId" DataSetColumn="PaymentTermId" />
              <Mapping SourceColumn="DeliveryTermId" DataSetColumn="DeliveryTermId" />
              <Mapping SourceColumn="ExpensePercentageId" DataSetColumn="ExpensePercentageId" />
              <Mapping SourceColumn="CarrierId" DataSetColumn="CarrierId" />
              <Mapping SourceColumn="ReferansNo" DataSetColumn="ReferansNo" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FaturaDetayTableAdapter" GeneratorDataComponentClassName="FaturaDetayTableAdapter" Name="FaturaDetay" UserDataComponentName="FaturaDetayTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.FaturaDetay" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[FaturaDetay] WHERE (([FaturaDetayId] = @Original_FaturaDetayId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FaturaDetayId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaDetayId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[FaturaDetay] ([FaturaId], [ProductId], [CustomerId], [TotalQty], [LineTotal], [SatinalmaOKi], [isClosed], [ModifiedDate], [ModifiedBy]) VALUES (@FaturaId, @ProductId, @CustomerId, @TotalQty, @LineTotal, @SatinalmaOKi, @isClosed, @ModifiedDate, @ModifiedBy);
SELECT FaturaDetayId, FaturaId, ProductId, CustomerId, TotalQty, LineTotal, SatinalmaOKi, isClosed, ModifiedDate, ModifiedBy, TS FROM FaturaDetay WHERE (FaturaDetayId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FaturaId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalQty" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalQty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@LineTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="LineTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SatinalmaOKi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SatinalmaOKi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isClosed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isClosed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT FaturaDetayId, FaturaId, ProductId, CustomerId, TotalQty, LineTotal, SatinalmaOKi, isClosed, ModifiedDate, ModifiedBy, TS FROM dbo.FaturaDetay</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[FaturaDetay] SET [FaturaId] = @FaturaId, [ProductId] = @ProductId, [CustomerId] = @CustomerId, [TotalQty] = @TotalQty, [LineTotal] = @LineTotal, [SatinalmaOKi] = @SatinalmaOKi, [isClosed] = @isClosed, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([FaturaDetayId] = @Original_FaturaDetayId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT FaturaDetayId, FaturaId, ProductId, CustomerId, TotalQty, LineTotal, SatinalmaOKi, isClosed, ModifiedDate, ModifiedBy, TS FROM FaturaDetay WHERE (FaturaDetayId = @FaturaDetayId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FaturaId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalQty" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalQty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@LineTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="LineTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SatinalmaOKi" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SatinalmaOKi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isClosed" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isClosed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FaturaDetayId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaDetayId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="FaturaDetayId" ColumnName="FaturaDetayId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@FaturaDetayId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FaturaDetayId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FaturaDetayId" DataSetColumn="FaturaDetayId" />
              <Mapping SourceColumn="FaturaId" DataSetColumn="FaturaId" />
              <Mapping SourceColumn="ProductId" DataSetColumn="ProductId" />
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="TotalQty" DataSetColumn="TotalQty" />
              <Mapping SourceColumn="LineTotal" DataSetColumn="LineTotal" />
              <Mapping SourceColumn="SatinalmaOKi" DataSetColumn="SatinalmaOKi" />
              <Mapping SourceColumn="isClosed" DataSetColumn="isClosed" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.FaturaDetay" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFaturaId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByFaturaId" GeneratorSourceName="FillByFaturaId" GetMethodModifier="Public" GetMethodName="GetDataByFaturaId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByFaturaId" UserSourceName="FillByFaturaId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FaturaDetayId, FaturaId, ProductId, CustomerId, TotalQty, LineTotal, SatinalmaOKi, isClosed, ModifiedDate, ModifiedBy, TS FROM dbo.FaturaDetay
where FaturaId = @FaturaId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="FaturaId" ColumnName="FaturaId" DataSourceName="Karbel4.dbo.FaturaDetay" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@FaturaId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FaturaId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FeatureKumasTableAdapter" GeneratorDataComponentClassName="FeatureKumasTableAdapter" Name="FeatureKumas" UserDataComponentName="FeatureKumasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.FeatureKumas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[FeatureKumas] WHERE (([FaturaDetayId] = @Original_FaturaDetayId) AND ((@IsNull_Weight = 1 AND [Weight] IS NULL) OR ([Weight] = @Original_Weight)) AND ((@IsNull_UnitMeasureId = 1 AND [UnitMeasureId] IS NULL) OR ([UnitMeasureId] = @Original_UnitMeasureId)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_IplikNo = 1 AND [IplikNo] IS NULL) OR ([IplikNo] = @Original_IplikNo)) AND ((@IsNull_Quality = 1 AND [Quality] IS NULL) OR ([Quality] = @Original_Quality)) AND ((@IsNull_Composition = 1 AND [Composition] IS NULL) OR ([Composition] = @Original_Composition)) AND ((@IsNull_Construction = 1 AND [Construction] IS NULL) OR ([Construction] = @Original_Construction)) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)) AND ((@IsNull_UreticiArtikeli = 1 AND [UreticiArtikeli] IS NULL) OR ([UreticiArtikeli] = @Original_UreticiArtikeli)) AND ((@IsNull_UreticiKodu = 1 AND [UreticiKodu] IS NULL) OR ([UreticiKodu] = @Original_UreticiKodu)) AND ((@IsNull_UreticiRenk = 1 AND [UreticiRenk] IS NULL) OR ([UreticiRenk] = @Original_UreticiRenk)) AND ((@IsNull_KarbelArtikeli = 1 AND [KarbelArtikeli] IS NULL) OR ([KarbelArtikeli] = @Original_KarbelArtikeli)) AND ((@IsNull_KarbelKodu = 1 AND [KarbelKodu] IS NULL) OR ([KarbelKodu] = @Original_KarbelKodu)) AND ((@IsNull_KarbelRenk = 1 AND [KarbelRenk] IS NULL) OR ([KarbelRenk] = @Original_KarbelRenk)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FaturaDetayId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaDetayId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UnitMeasureId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitMeasureId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UnitMeasureId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UnitMeasureId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IplikNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IplikNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_IplikNo" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="IplikNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Quality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Quality" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Quality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Composition" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Composition" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Construction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Construction" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Construction" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Construction" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UreticiArtikeli" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UreticiArtikeli" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UreticiArtikeli" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiArtikeli" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UreticiKodu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UreticiKodu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UreticiKodu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiKodu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UreticiRenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UreticiRenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UreticiRenk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiRenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KarbelArtikeli" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KarbelArtikeli" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_KarbelArtikeli" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelArtikeli" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KarbelKodu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KarbelKodu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_KarbelKodu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelKodu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KarbelRenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KarbelRenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_KarbelRenk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelRenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[FeatureKumas] ([FaturaDetayId], [Notes], [Weight], [UnitMeasureId], [Width], [IplikNo], [Quality], [Composition], [Construction], [Type], [UreticiArtikeli], [UreticiKodu], [UreticiRenk], [KarbelArtikeli], [KarbelKodu], [KarbelRenk]) VALUES (@FaturaDetayId, @Notes, @Weight, @UnitMeasureId, @Width, @IplikNo, @Quality, @Composition, @Construction, @Type, @UreticiArtikeli, @UreticiKodu, @UreticiRenk, @KarbelArtikeli, @KarbelKodu, @KarbelRenk);
SELECT FaturaDetayId, Notes, Weight, UnitMeasureId, Width, IplikNo, Quality, Composition, Construction, Type, UreticiArtikeli, UreticiKodu, UreticiRenk, KarbelArtikeli, KarbelKodu, KarbelRenk FROM FeatureKumas WHERE (FaturaDetayId = @FaturaDetayId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FaturaDetayId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaDetayId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UnitMeasureId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UnitMeasureId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@IplikNo" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="IplikNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Quality" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Quality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Composition" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Construction" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Construction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UreticiArtikeli" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiArtikeli" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UreticiKodu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiKodu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UreticiRenk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiRenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KarbelArtikeli" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelArtikeli" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KarbelKodu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelKodu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KarbelRenk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelRenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT FaturaDetayId, Notes, Weight, UnitMeasureId, Width, IplikNo, Quality, Composition, Construction, Type, UreticiArtikeli, UreticiKodu, UreticiRenk, KarbelArtikeli, KarbelKodu, KarbelRenk FROM dbo.FeatureKumas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[FeatureKumas] SET [FaturaDetayId] = @FaturaDetayId, [Notes] = @Notes, [Weight] = @Weight, [UnitMeasureId] = @UnitMeasureId, [Width] = @Width, [IplikNo] = @IplikNo, [Quality] = @Quality, [Composition] = @Composition, [Construction] = @Construction, [Type] = @Type, [UreticiArtikeli] = @UreticiArtikeli, [UreticiKodu] = @UreticiKodu, [UreticiRenk] = @UreticiRenk, [KarbelArtikeli] = @KarbelArtikeli, [KarbelKodu] = @KarbelKodu, [KarbelRenk] = @KarbelRenk WHERE (([FaturaDetayId] = @Original_FaturaDetayId) AND ((@IsNull_Weight = 1 AND [Weight] IS NULL) OR ([Weight] = @Original_Weight)) AND ((@IsNull_UnitMeasureId = 1 AND [UnitMeasureId] IS NULL) OR ([UnitMeasureId] = @Original_UnitMeasureId)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_IplikNo = 1 AND [IplikNo] IS NULL) OR ([IplikNo] = @Original_IplikNo)) AND ((@IsNull_Quality = 1 AND [Quality] IS NULL) OR ([Quality] = @Original_Quality)) AND ((@IsNull_Composition = 1 AND [Composition] IS NULL) OR ([Composition] = @Original_Composition)) AND ((@IsNull_Construction = 1 AND [Construction] IS NULL) OR ([Construction] = @Original_Construction)) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)) AND ((@IsNull_UreticiArtikeli = 1 AND [UreticiArtikeli] IS NULL) OR ([UreticiArtikeli] = @Original_UreticiArtikeli)) AND ((@IsNull_UreticiKodu = 1 AND [UreticiKodu] IS NULL) OR ([UreticiKodu] = @Original_UreticiKodu)) AND ((@IsNull_UreticiRenk = 1 AND [UreticiRenk] IS NULL) OR ([UreticiRenk] = @Original_UreticiRenk)) AND ((@IsNull_KarbelArtikeli = 1 AND [KarbelArtikeli] IS NULL) OR ([KarbelArtikeli] = @Original_KarbelArtikeli)) AND ((@IsNull_KarbelKodu = 1 AND [KarbelKodu] IS NULL) OR ([KarbelKodu] = @Original_KarbelKodu)) AND ((@IsNull_KarbelRenk = 1 AND [KarbelRenk] IS NULL) OR ([KarbelRenk] = @Original_KarbelRenk)));
SELECT FaturaDetayId, Notes, Weight, UnitMeasureId, Width, IplikNo, Quality, Composition, Construction, Type, UreticiArtikeli, UreticiKodu, UreticiRenk, KarbelArtikeli, KarbelKodu, KarbelRenk FROM FeatureKumas WHERE (FaturaDetayId = @FaturaDetayId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FaturaDetayId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaDetayId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UnitMeasureId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UnitMeasureId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@IplikNo" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="IplikNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Quality" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Quality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Composition" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Construction" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Construction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UreticiArtikeli" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiArtikeli" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UreticiKodu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiKodu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UreticiRenk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiRenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KarbelArtikeli" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelArtikeli" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KarbelKodu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelKodu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KarbelRenk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelRenk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FaturaDetayId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaDetayId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UnitMeasureId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UnitMeasureId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UnitMeasureId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UnitMeasureId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IplikNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IplikNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_IplikNo" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="IplikNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Quality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Quality" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Quality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Composition" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Composition" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Composition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Construction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Construction" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Construction" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Construction" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UreticiArtikeli" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UreticiArtikeli" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UreticiArtikeli" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiArtikeli" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UreticiKodu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UreticiKodu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UreticiKodu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiKodu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UreticiRenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UreticiRenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UreticiRenk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UreticiRenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KarbelArtikeli" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KarbelArtikeli" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_KarbelArtikeli" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelArtikeli" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KarbelKodu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KarbelKodu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_KarbelKodu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelKodu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KarbelRenk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KarbelRenk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_KarbelRenk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KarbelRenk" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FaturaDetayId" DataSetColumn="FaturaDetayId" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
              <Mapping SourceColumn="Weight" DataSetColumn="Weight" />
              <Mapping SourceColumn="UnitMeasureId" DataSetColumn="UnitMeasureId" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
              <Mapping SourceColumn="IplikNo" DataSetColumn="IplikNo" />
              <Mapping SourceColumn="Quality" DataSetColumn="Quality" />
              <Mapping SourceColumn="Composition" DataSetColumn="Composition" />
              <Mapping SourceColumn="Construction" DataSetColumn="Construction" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="UreticiArtikeli" DataSetColumn="UreticiArtikeli" />
              <Mapping SourceColumn="UreticiKodu" DataSetColumn="UreticiKodu" />
              <Mapping SourceColumn="UreticiRenk" DataSetColumn="UreticiRenk" />
              <Mapping SourceColumn="KarbelArtikeli" DataSetColumn="KarbelArtikeli" />
              <Mapping SourceColumn="KarbelKodu" DataSetColumn="KarbelKodu" />
              <Mapping SourceColumn="KarbelRenk" DataSetColumn="KarbelRenk" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.FeatureKumas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFaturaId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByFaturaId" GeneratorSourceName="FillByFaturaId" GetMethodModifier="Public" GetMethodName="GetDataByFaturaId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByFaturaId" UserSourceName="FillByFaturaId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT FaturaDetayId, Notes, Weight, UnitMeasureId, Width, IplikNo, Quality, Composition, Construction, Type, UreticiArtikeli, UreticiKodu, UreticiRenk, KarbelArtikeli, KarbelKodu, KarbelRenk FROM dbo.FeatureKumas
where FaturaDetayId in (select FaturaDetayId from FaturaDetay where FaturaId = @FaturaId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="FaturaId" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@FaturaId" Precision="0" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RollTableAdapter" GeneratorDataComponentClassName="RollTableAdapter" Name="Roll" UserDataComponentName="RollTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.Roll" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Roll] WHERE (([TopId] = @Original_TopId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TopId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TopId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Roll] ([FaturaDetayId], [En], [Kalite], [InitialQty], [UnitPrice], [isRunOut], [ModifiedDate], [ModifiedBy]) VALUES (@FaturaDetayId, @En, @Kalite, @InitialQty, @UnitPrice, @isRunOut, @ModifiedDate, @ModifiedBy);
SELECT TopId, FaturaDetayId, En, Kalite, InitialQty, UnitPrice, isRunOut, ModifiedDate, ModifiedBy, TS FROM Roll WHERE (TopId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FaturaDetayId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaDetayId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@En" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="En" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Kalite" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Kalite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@InitialQty" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="InitialQty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@UnitPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UnitPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isRunOut" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isRunOut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT TopId, FaturaDetayId, En, Kalite, InitialQty, UnitPrice, isRunOut, ModifiedDate, ModifiedBy, TS FROM dbo.Roll</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Roll] SET [FaturaDetayId] = @FaturaDetayId, [En] = @En, [Kalite] = @Kalite, [InitialQty] = @InitialQty, [UnitPrice] = @UnitPrice, [isRunOut] = @isRunOut, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([TopId] = @Original_TopId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT TopId, FaturaDetayId, En, Kalite, InitialQty, UnitPrice, isRunOut, ModifiedDate, ModifiedBy, TS FROM Roll WHERE (TopId = @TopId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FaturaDetayId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaturaDetayId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@En" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="En" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Kalite" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Kalite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@InitialQty" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="InitialQty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@UnitPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UnitPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isRunOut" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isRunOut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TopId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TopId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TopId" ColumnName="TopId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TopId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TopId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TopId" DataSetColumn="TopId" />
              <Mapping SourceColumn="FaturaDetayId" DataSetColumn="FaturaDetayId" />
              <Mapping SourceColumn="En" DataSetColumn="En" />
              <Mapping SourceColumn="Kalite" DataSetColumn="Kalite" />
              <Mapping SourceColumn="InitialQty" DataSetColumn="InitialQty" />
              <Mapping SourceColumn="UnitPrice" DataSetColumn="UnitPrice" />
              <Mapping SourceColumn="isRunOut" DataSetColumn="isRunOut" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.Roll" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFaturaId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByFaturaId" GeneratorSourceName="FillByFaturaId" GetMethodModifier="Public" GetMethodName="GetDataByFaturaId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByFaturaId" UserSourceName="FillByFaturaId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TopId, FaturaDetayId, En, Kalite, InitialQty, UnitPrice, isRunOut, ModifiedDate, ModifiedBy, TS FROM dbo.Roll
where FaturaDetayId in (select FaturaDetayId from FaturaDetay where FaturaId = @FaturaId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="FaturaId" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@FaturaId" Precision="0" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DSFatura" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="DSFatura" msprop:Generator_UserDSName="DSFatura" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Fatura" msprop:Generator_UserTableName="Fatura" msprop:Generator_RowDeletedName="FaturaRowDeleted" msprop:Generator_TableClassName="FaturaDataTable" msprop:Generator_RowChangedName="FaturaRowChanged" msprop:Generator_RowClassName="FaturaRow" msprop:Generator_RowChangingName="FaturaRowChanging" msprop:Generator_RowEvArgName="FaturaRowChangeEvent" msprop:Generator_RowEvHandlerName="FaturaRowChangeEventHandler" msprop:Generator_TablePropName="Fatura" msprop:Generator_TableVarName="tableFatura" msprop:Generator_RowDeletingName="FaturaRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FaturaId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="FaturaId" msprop:Generator_ColumnPropNameInRow="FaturaId" msprop:Generator_ColumnVarNameInTable="columnFaturaId" msprop:Generator_ColumnPropNameInTable="FaturaIdColumn" type="xs:int" />
              <xs:element name="PurchaseOrderId" msprop:Generator_UserColumnName="PurchaseOrderId" msprop:Generator_ColumnPropNameInRow="PurchaseOrderId" msprop:Generator_ColumnVarNameInTable="columnPurchaseOrderId" msprop:Generator_ColumnPropNameInTable="PurchaseOrderIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Tarih" msprop:Generator_UserColumnName="Tarih" msprop:Generator_ColumnPropNameInRow="Tarih" msprop:Generator_ColumnVarNameInTable="columnTarih" msprop:Generator_ColumnPropNameInTable="TarihColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="BelgeTipiId" msprop:Generator_UserColumnName="BelgeTipiId" msprop:Generator_ColumnPropNameInRow="BelgeTipiId" msprop:Generator_ColumnVarNameInTable="columnBelgeTipiId" msprop:Generator_ColumnPropNameInTable="BelgeTipiIdColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="FaturaTarihi" msprop:Generator_UserColumnName="FaturaTarihi" msprop:Generator_ColumnPropNameInRow="FaturaTarihi" msprop:Generator_ColumnVarNameInTable="columnFaturaTarihi" msprop:Generator_ColumnPropNameInTable="FaturaTarihiColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FaturaNo" msprop:Generator_UserColumnName="FaturaNo" msprop:Generator_ColumnPropNameInRow="FaturaNo" msprop:Generator_ColumnVarNameInTable="columnFaturaNo" msprop:Generator_ColumnPropNameInTable="FaturaNoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IrsaliyeTarihi" msprop:Generator_UserColumnName="IrsaliyeTarihi" msprop:Generator_ColumnPropNameInRow="IrsaliyeTarihi" msprop:Generator_ColumnVarNameInTable="columnIrsaliyeTarihi" msprop:Generator_ColumnPropNameInTable="IrsaliyeTarihiColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IrsaliyeNo" msprop:Generator_UserColumnName="IrsaliyeNo" msprop:Generator_ColumnPropNameInRow="IrsaliyeNo" msprop:Generator_ColumnVarNameInTable="columnIrsaliyeNo" msprop:Generator_ColumnPropNameInTable="IrsaliyeNoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VendorId" msprop:Generator_UserColumnName="VendorId" msprop:Generator_ColumnPropNameInRow="VendorId" msprop:Generator_ColumnVarNameInTable="columnVendorId" msprop:Generator_ColumnPropNameInTable="VendorIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="isClosed" msprop:Generator_UserColumnName="isClosed" msprop:Generator_ColumnPropNameInRow="isClosed" msprop:Generator_ColumnVarNameInTable="columnisClosed" msprop:Generator_ColumnPropNameInTable="isClosedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="OwnerId" msprop:Generator_UserColumnName="OwnerId" msprop:Generator_ColumnPropNameInRow="OwnerId" msprop:Generator_ColumnVarNameInTable="columnOwnerId" msprop:Generator_ColumnPropNameInTable="OwnerIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CurrencyCode" msprop:Generator_UserColumnName="CurrencyCode" msprop:Generator_ColumnPropNameInRow="CurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCurrencyCode" msprop:Generator_ColumnPropNameInTable="CurrencyCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Freight" msprop:Generator_UserColumnName="Freight" msprop:Generator_ColumnPropNameInRow="Freight" msprop:Generator_ColumnVarNameInTable="columnFreight" msprop:Generator_ColumnPropNameInTable="FreightColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="GrandTotal" msprop:Generator_UserColumnName="GrandTotal" msprop:Generator_ColumnPropNameInRow="GrandTotal" msprop:Generator_ColumnVarNameInTable="columnGrandTotal" msprop:Generator_ColumnPropNameInTable="GrandTotalColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="AlisSekliId" msprop:Generator_UserColumnName="AlisSekliId" msprop:Generator_ColumnPropNameInRow="AlisSekliId" msprop:Generator_ColumnVarNameInTable="columnAlisSekliId" msprop:Generator_ColumnPropNameInTable="AlisSekliIdColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="PaymentTermId" msprop:Generator_UserColumnName="PaymentTermId" msprop:Generator_ColumnPropNameInRow="PaymentTermId" msprop:Generator_ColumnVarNameInTable="columnPaymentTermId" msprop:Generator_ColumnPropNameInTable="PaymentTermIdColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="DeliveryTermId" msprop:Generator_UserColumnName="DeliveryTermId" msprop:Generator_ColumnPropNameInRow="DeliveryTermId" msprop:Generator_ColumnVarNameInTable="columnDeliveryTermId" msprop:Generator_ColumnPropNameInTable="DeliveryTermIdColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="ExpensePercentageId" msprop:Generator_UserColumnName="ExpensePercentageId" msprop:Generator_ColumnPropNameInRow="ExpensePercentageId" msprop:Generator_ColumnVarNameInTable="columnExpensePercentageId" msprop:Generator_ColumnPropNameInTable="ExpensePercentageIdColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="CarrierId" msprop:Generator_UserColumnName="CarrierId" msprop:Generator_ColumnPropNameInRow="CarrierId" msprop:Generator_ColumnVarNameInTable="columnCarrierId" msprop:Generator_ColumnPropNameInTable="CarrierIdColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ReferansNo" msprop:Generator_UserColumnName="ReferansNo" msprop:Generator_ColumnPropNameInRow="ReferansNo" msprop:Generator_ColumnVarNameInTable="columnReferansNo" msprop:Generator_ColumnPropNameInTable="ReferansNoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="FaturaDetay" msprop:Generator_UserTableName="FaturaDetay" msprop:Generator_RowDeletedName="FaturaDetayRowDeleted" msprop:Generator_TableClassName="FaturaDetayDataTable" msprop:Generator_RowChangedName="FaturaDetayRowChanged" msprop:Generator_RowClassName="FaturaDetayRow" msprop:Generator_RowChangingName="FaturaDetayRowChanging" msprop:Generator_RowEvArgName="FaturaDetayRowChangeEvent" msprop:Generator_RowEvHandlerName="FaturaDetayRowChangeEventHandler" msprop:Generator_TablePropName="FaturaDetay" msprop:Generator_TableVarName="tableFaturaDetay" msprop:Generator_RowDeletingName="FaturaDetayRowDeleting" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="FaturaDetayId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="FaturaDetayId" msprop:Generator_ColumnPropNameInRow="FaturaDetayId" msprop:Generator_ColumnVarNameInTable="columnFaturaDetayId" msprop:Generator_ColumnPropNameInTable="FaturaDetayIdColumn" type="xs:int" />
                    <xs:element name="FaturaId" msprop:Generator_UserColumnName="FaturaId" msprop:Generator_ColumnPropNameInRow="FaturaId" msprop:Generator_ColumnVarNameInTable="columnFaturaId" msprop:Generator_ColumnPropNameInTable="FaturaIdColumn" type="xs:int" minOccurs="0" />
                    <xs:element name="ProductId" msprop:Generator_UserColumnName="ProductId" msprop:Generator_ColumnPropNameInRow="ProductId" msprop:Generator_ColumnVarNameInTable="columnProductId" msprop:Generator_ColumnPropNameInTable="ProductIdColumn" type="xs:int" minOccurs="0" />
                    <xs:element name="CustomerId" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" minOccurs="0" />
                    <xs:element name="TotalQty" msprop:Generator_UserColumnName="TotalQty" msprop:Generator_ColumnPropNameInRow="TotalQty" msprop:Generator_ColumnVarNameInTable="columnTotalQty" msprop:Generator_ColumnPropNameInTable="TotalQtyColumn" type="xs:double" minOccurs="0" />
                    <xs:element name="LineTotal" msprop:Generator_UserColumnName="LineTotal" msprop:Generator_ColumnPropNameInRow="LineTotal" msprop:Generator_ColumnVarNameInTable="columnLineTotal" msprop:Generator_ColumnPropNameInTable="LineTotalColumn" type="xs:decimal" minOccurs="0" />
                    <xs:element name="SatinalmaOKi" msprop:Generator_UserColumnName="SatinalmaOKi" msprop:Generator_ColumnPropNameInRow="SatinalmaOKi" msprop:Generator_ColumnVarNameInTable="columnSatinalmaOKi" msprop:Generator_ColumnPropNameInTable="SatinalmaOKiColumn" type="xs:boolean" minOccurs="0" />
                    <xs:element name="isClosed" msprop:Generator_UserColumnName="isClosed" msprop:Generator_ColumnPropNameInRow="isClosed" msprop:Generator_ColumnVarNameInTable="columnisClosed" msprop:Generator_ColumnPropNameInTable="isClosedColumn" type="xs:boolean" minOccurs="0" />
                    <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
                    <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
                    <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
                    <xs:element name="FeatureKumas" msprop:Generator_UserTableName="FeatureKumas" msprop:Generator_RowDeletedName="FeatureKumasRowDeleted" msprop:Generator_TableClassName="FeatureKumasDataTable" msprop:Generator_RowChangedName="FeatureKumasRowChanged" msprop:Generator_RowClassName="FeatureKumasRow" msprop:Generator_RowChangingName="FeatureKumasRowChanging" msprop:Generator_RowEvArgName="FeatureKumasRowChangeEvent" msprop:Generator_RowEvHandlerName="FeatureKumasRowChangeEventHandler" msprop:Generator_TablePropName="FeatureKumas" msprop:Generator_TableVarName="tableFeatureKumas" msprop:Generator_RowDeletingName="FeatureKumasRowDeleting" minOccurs="0" maxOccurs="unbounded">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element name="FaturaDetayId" msprop:Generator_UserColumnName="FaturaDetayId" msprop:Generator_ColumnPropNameInRow="FaturaDetayId" msprop:Generator_ColumnVarNameInTable="columnFaturaDetayId" msprop:Generator_ColumnPropNameInTable="FaturaDetayIdColumn" type="xs:int" />
                          <xs:element name="Notes" msprop:Generator_UserColumnName="Notes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInTable="NotesColumn" minOccurs="0">
                            <xs:simpleType>
                              <xs:restriction base="xs:string">
                                <xs:maxLength value="2147483647" />
                              </xs:restriction>
                            </xs:simpleType>
                          </xs:element>
                          <xs:element name="Weight" msprop:Generator_UserColumnName="Weight" msprop:Generator_ColumnPropNameInRow="Weight" msprop:Generator_ColumnVarNameInTable="columnWeight" msprop:Generator_ColumnPropNameInTable="WeightColumn" type="xs:int" minOccurs="0" />
                          <xs:element name="UnitMeasureId" msprop:Generator_UserColumnName="UnitMeasureId" msprop:Generator_ColumnPropNameInRow="UnitMeasureId" msprop:Generator_ColumnVarNameInTable="columnUnitMeasureId" msprop:Generator_ColumnPropNameInTable="UnitMeasureIdColumn" minOccurs="0">
                            <xs:simpleType>
                              <xs:restriction base="xs:string">
                                <xs:maxLength value="3" />
                              </xs:restriction>
                            </xs:simpleType>
                          </xs:element>
                          <xs:element name="Width" msprop:Generator_UserColumnName="Width" msprop:Generator_ColumnPropNameInRow="Width" msprop:Generator_ColumnVarNameInTable="columnWidth" msprop:Generator_ColumnPropNameInTable="WidthColumn" type="xs:int" minOccurs="0" />
                          <xs:element name="IplikNo" msprop:Generator_UserColumnName="IplikNo" msprop:Generator_ColumnPropNameInRow="IplikNo" msprop:Generator_ColumnVarNameInTable="columnIplikNo" msprop:Generator_ColumnPropNameInTable="IplikNoColumn" type="xs:unsignedByte" minOccurs="0" />
                          <xs:element name="Quality" msprop:Generator_UserColumnName="Quality" msprop:Generator_ColumnPropNameInRow="Quality" msprop:Generator_ColumnVarNameInTable="columnQuality" msprop:Generator_ColumnPropNameInTable="QualityColumn" type="xs:unsignedByte" minOccurs="0" />
                          <xs:element name="Composition" msprop:Generator_UserColumnName="Composition" msprop:Generator_ColumnPropNameInRow="Composition" msprop:Generator_ColumnVarNameInTable="columnComposition" msprop:Generator_ColumnPropNameInTable="CompositionColumn" type="xs:unsignedByte" minOccurs="0" />
                          <xs:element name="Construction" msprop:Generator_UserColumnName="Construction" msprop:Generator_ColumnPropNameInRow="Construction" msprop:Generator_ColumnVarNameInTable="columnConstruction" msprop:Generator_ColumnPropNameInTable="ConstructionColumn" type="xs:unsignedByte" minOccurs="0" />
                          <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" type="xs:unsignedByte" minOccurs="0" />
                          <xs:element name="UreticiArtikeli" msprop:Generator_UserColumnName="UreticiArtikeli" msprop:Generator_ColumnPropNameInRow="UreticiArtikeli" msprop:Generator_ColumnVarNameInTable="columnUreticiArtikeli" msprop:Generator_ColumnPropNameInTable="UreticiArtikeliColumn" minOccurs="0">
                            <xs:simpleType>
                              <xs:restriction base="xs:string">
                                <xs:maxLength value="50" />
                              </xs:restriction>
                            </xs:simpleType>
                          </xs:element>
                          <xs:element name="UreticiKodu" msprop:Generator_UserColumnName="UreticiKodu" msprop:Generator_ColumnPropNameInRow="UreticiKodu" msprop:Generator_ColumnVarNameInTable="columnUreticiKodu" msprop:Generator_ColumnPropNameInTable="UreticiKoduColumn" minOccurs="0">
                            <xs:simpleType>
                              <xs:restriction base="xs:string">
                                <xs:maxLength value="50" />
                              </xs:restriction>
                            </xs:simpleType>
                          </xs:element>
                          <xs:element name="UreticiRenk" msprop:Generator_UserColumnName="UreticiRenk" msprop:Generator_ColumnPropNameInRow="UreticiRenk" msprop:Generator_ColumnVarNameInTable="columnUreticiRenk" msprop:Generator_ColumnPropNameInTable="UreticiRenkColumn" minOccurs="0">
                            <xs:simpleType>
                              <xs:restriction base="xs:string">
                                <xs:maxLength value="50" />
                              </xs:restriction>
                            </xs:simpleType>
                          </xs:element>
                          <xs:element name="KarbelArtikeli" msprop:Generator_UserColumnName="KarbelArtikeli" msprop:Generator_ColumnPropNameInRow="KarbelArtikeli" msprop:Generator_ColumnVarNameInTable="columnKarbelArtikeli" msprop:Generator_ColumnPropNameInTable="KarbelArtikeliColumn" minOccurs="0">
                            <xs:simpleType>
                              <xs:restriction base="xs:string">
                                <xs:maxLength value="50" />
                              </xs:restriction>
                            </xs:simpleType>
                          </xs:element>
                          <xs:element name="KarbelKodu" msprop:Generator_UserColumnName="KarbelKodu" msprop:Generator_ColumnPropNameInRow="KarbelKodu" msprop:Generator_ColumnVarNameInTable="columnKarbelKodu" msprop:Generator_ColumnPropNameInTable="KarbelKoduColumn" minOccurs="0">
                            <xs:simpleType>
                              <xs:restriction base="xs:string">
                                <xs:maxLength value="50" />
                              </xs:restriction>
                            </xs:simpleType>
                          </xs:element>
                          <xs:element name="KarbelRenk" msprop:Generator_UserColumnName="KarbelRenk" msprop:Generator_ColumnPropNameInRow="KarbelRenk" msprop:Generator_ColumnVarNameInTable="columnKarbelRenk" msprop:Generator_ColumnPropNameInTable="KarbelRenkColumn" minOccurs="0">
                            <xs:simpleType>
                              <xs:restriction base="xs:string">
                                <xs:maxLength value="50" />
                              </xs:restriction>
                            </xs:simpleType>
                          </xs:element>
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                    <xs:element name="Roll" msprop:Generator_UserTableName="Roll" msprop:Generator_RowDeletedName="RollRowDeleted" msprop:Generator_TableClassName="RollDataTable" msprop:Generator_RowChangedName="RollRowChanged" msprop:Generator_RowClassName="RollRow" msprop:Generator_RowChangingName="RollRowChanging" msprop:Generator_RowEvArgName="RollRowChangeEvent" msprop:Generator_RowEvHandlerName="RollRowChangeEventHandler" msprop:Generator_TablePropName="Roll" msprop:Generator_TableVarName="tableRoll" msprop:Generator_RowDeletingName="RollRowDeleting" minOccurs="0" maxOccurs="unbounded">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element name="TopId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="TopId" msprop:Generator_ColumnPropNameInRow="TopId" msprop:Generator_ColumnVarNameInTable="columnTopId" msprop:Generator_ColumnPropNameInTable="TopIdColumn" type="xs:int" />
                          <xs:element name="FaturaDetayId" msprop:Generator_UserColumnName="FaturaDetayId" msprop:Generator_ColumnPropNameInRow="FaturaDetayId" msprop:Generator_ColumnVarNameInTable="columnFaturaDetayId" msprop:Generator_ColumnPropNameInTable="FaturaDetayIdColumn" type="xs:int" minOccurs="0" />
                          <xs:element name="En" msprop:Generator_UserColumnName="En" msprop:Generator_ColumnPropNameInRow="En" msprop:Generator_ColumnVarNameInTable="columnEn" msprop:Generator_ColumnPropNameInTable="EnColumn" type="xs:double" minOccurs="0" />
                          <xs:element name="Kalite" msprop:Generator_UserColumnName="Kalite" msprop:Generator_ColumnPropNameInRow="Kalite" msprop:Generator_ColumnVarNameInTable="columnKalite" msprop:Generator_ColumnPropNameInTable="KaliteColumn" type="xs:unsignedByte" minOccurs="0" />
                          <xs:element name="InitialQty" msprop:Generator_UserColumnName="InitialQty" msprop:Generator_ColumnPropNameInRow="InitialQty" msprop:Generator_ColumnVarNameInTable="columnInitialQty" msprop:Generator_ColumnPropNameInTable="InitialQtyColumn" type="xs:double" minOccurs="0" />
                          <xs:element name="UnitPrice" msprop:Generator_UserColumnName="UnitPrice" msprop:Generator_ColumnPropNameInRow="UnitPrice" msprop:Generator_ColumnVarNameInTable="columnUnitPrice" msprop:Generator_ColumnPropNameInTable="UnitPriceColumn" type="xs:decimal" minOccurs="0" />
                          <xs:element name="isRunOut" msprop:Generator_UserColumnName="isRunOut" msprop:Generator_ColumnPropNameInRow="isRunOut" msprop:Generator_ColumnVarNameInTable="columnisRunOut" msprop:Generator_ColumnPropNameInTable="isRunOutColumn" type="xs:boolean" minOccurs="0" />
                          <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
                          <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
                          <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="FeatureKumas_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FeatureKumas" />
      <xs:field xpath="mstns:FaturaDetayId" />
    </xs:unique>
    <xs:unique name="Roll_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Roll" />
      <xs:field xpath="mstns:TopId" />
    </xs:unique>
    <xs:unique name="FaturaDetay_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FaturaDetay" />
      <xs:field xpath="mstns:FaturaDetayId" />
    </xs:unique>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Fatura" />
      <xs:field xpath="mstns:FaturaId" />
    </xs:unique>
    <xs:keyref name="FK_BelgeDetay_Belge" refer="Constraint1" msdata:IsNested="true" msprop:rel_Generator_UserRelationName="FK_BelgeDetay_Belge" msprop:rel_Generator_RelationVarName="relationFK_BelgeDetay_Belge" msprop:rel_Generator_UserChildTable="FaturaDetay" msprop:rel_Generator_UserParentTable="Fatura" msprop:rel_Generator_ParentPropName="FaturaRow" msprop:rel_Generator_ChildPropName="GetFaturaDetayRows">
      <xs:selector xpath=".//mstns:FaturaDetay" />
      <xs:field xpath="mstns:FaturaId" />
    </xs:keyref>
    <xs:keyref name="FK_Top_BelgeDetay" refer="FaturaDetay_Constraint1" msdata:IsNested="true" msprop:rel_Generator_UserRelationName="FK_Top_BelgeDetay" msprop:rel_Generator_RelationVarName="relationFK_Top_BelgeDetay" msprop:rel_Generator_UserChildTable="Roll" msprop:rel_Generator_UserParentTable="FaturaDetay" msprop:rel_Generator_ParentPropName="FaturaDetayRow" msprop:rel_Generator_ChildPropName="GetRollRows">
      <xs:selector xpath=".//mstns:Roll" />
      <xs:field xpath="mstns:FaturaDetayId" />
    </xs:keyref>
    <xs:keyref name="FK_FeatureKumas_BelgeDetay" refer="FaturaDetay_Constraint1" msdata:IsNested="true" msprop:rel_Generator_UserRelationName="FK_FeatureKumas_BelgeDetay" msprop:rel_Generator_RelationVarName="relationFK_FeatureKumas_BelgeDetay" msprop:rel_Generator_UserChildTable="FeatureKumas" msprop:rel_Generator_UserParentTable="FaturaDetay" msprop:rel_Generator_ParentPropName="FaturaDetayRow" msprop:rel_Generator_ChildPropName="GetFeatureKumasRows">
      <xs:selector xpath=".//mstns:FeatureKumas" />
      <xs:field xpath="mstns:FaturaDetayId" />
    </xs:keyref>
  </xs:element>
</xs:schema>